Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012

Please note that Microsoft have retired this exam. Although the exam(s) associated with this course has been retired by Microsoft, this course still retains value as a training resource & learners will receive a certificate of completion after completing the course.

This course prepares students for the Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 exam. The course is specifically for participants to gain the knowledge and skills to make appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012.

• 12 months unlimited access
• Certificate of completion awarded upon completing the course to show to employers or prospective employers your new skills
• Free upgrade on to our premium platform
• Free career advice available upon request after completing the course

Today’s IT Industry demands that professionals cover the latest technology on the marketplace. Many IT professionals separate themselves from their competitors by achieving certifications in the most current technologies and giving themselves skill-sets that are unmatched by many of their peers.

This course prepares students for the Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 exam. The course is specifically for participants to gain the knowledge and skills to make appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012.

This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use. Primary responsibilities may include but are not limited to:

• BI Solution architecture and design Provisioning of software and hardware
• Data warehouse and data mart design
• Online Analytical Processing (OLAP) cube design
• Integration with SharePoint or line of business applications

Module Breakdown

Module 1: Intro to Business Intelligence

• 1.1 The Business Intelligence Solution
• 1.2 Overview of Business Intelligence
• 1.3 BI and Power Pivot Demo
• 1.4 ETL Intro
• 1.5 Designing Data Warehouses
• 1.6 Design for Speed
• 1.7 BI Semantic Model

Module 2: Database Essentials

• 2.1 Basic Database Objects Demo
• 2.2 Stored Procedures and Triggers Demo
• 2.3 Database Clusters Demo
• 2.4 SQL Server Management
• 2.5 Table Triggers
• 2.6 DB Configuring Options
• 2.7 DB Backup
• 2.8 DB Files and Restore

Module 3: Business Intelligence Development

• 3.1 Using SQL Server Data Tools Demo
• 3.2 Building an IS Integration Services Package Demo
• 3.3 Loading Data from Remote Sources Demo
• 3.4 Processing Data from Web Service Demo

Module 4: Business Intelligence Results

• 4.1 Report Building Intro Setup Demo
• 4.2 Using Report Builder Demo
• 4.3 Reporting from Multiple Tables Demo
• 4.4 Report Function and Matrix Demo
• 4.5 Interactive Reports Demo
• 4.6 Sorting Report Data Demo

Module 5: Advanced Reporting and Development

• 5.1 Drill through Reports
• 5.2 Data Visualization
• 5.3 Creating Store Procedure from Scratch
• 5.4 Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

• 6.1 Building Our First Integration Project
• 6.2 Data Transformation
• 6.3 Introduction to Big Data
• 6.4 Transformation Using Store Procedure
• 6.5 Transformation Using SSIS
• 6.6 Building Fact Table Using Store Procedure
• 6.7 Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

• 7.1 Backup Enhancements
• 7.2 Index Enhancements
• 7.3 Online DB Enhancements
• 7.4 Back Up to the Cloud
• 7.5 Partition Data

Module 8: Course Review and Exam Prep

• 8.1 BI Review
• 8.2 SharePoint Overview
• 8.3 SharePoint Demo
• 8.4 Exam Preparation
• 8.5 Before You Take the Exam

Why My Training Academy? My Training Academy’s training courses are light-years ahead of our competitors. We provide expert instructor-led training modules with customised presentations, practice exam simulators and learning supplements that provide the full benefits of live classroom training – you can study when and where you want, at your own pace.

Benefit? Our online courses are delivered by the industry’s finest instructors, with a minimum of 15 years real world experience and experts in their fields. You will learn all the relevant skills to support you in attaining your dream job. Gain the skills in demand by employers and the confidence that you’re one step closer to your dream job, promotion or new career.

Why not try the training for free? Request a free demo today at no extra cost.

Invest in yourself: Acquiring these vital business skills – will repay the cost in improved employment opportunities and job satisfaction. What better investment than in your own future? The sooner you start, the sooner you will benefit.

When can I start? Enquire today, simply enrol and you can start studying today if you wish.

What are our students saying about us? I have just bought the Networking Bundle from My Training Academy and can't wait to get started! The service received from John was first class, He gave me a fantastic price on the bundle which I really appreciated having recently been made redundant. Really helpful to have a free demo to see the course before buying. Really like this style of training it will suit me down to the ground, can’t thank you enough.

Certificate of completion

Digital certificate - Included